Using the Table Declaration wizard
Tables can be declared in the Control File and the Data Transformation script file. Table Declarations consist of information relating to the data to be loaded. In the Control File, table declarations appear after the references to the other script files.
The Table Declaration wizard is accessed from the Scripts tab. In the panel on the left of the screen, select the file that you want to add the Table Declaration to (either the Control file or the Data Transformation file). Click the Table Declaration button.
To edit existing Table Declarations, double-click on the text in the script display area of the screen on the right.
Table Definition File/Data Source File/Data List File
For each of the files, either enter the name of the file to be created, or click the Browse button
, and navigate to the path required.
You can create a new definition file by typing the name into the Table Definition File field. The file is then created when the import is run.
Format
Select the file type from the drop-down list. If you are importing a Unicode file you must ensure that the correct format is used.
Delimiter
Only active if the file format chosen is Delimited. Select the delimiter to use from the drop-down list.
Ignore CSV Validation
Only active if the file format chosen is Delimited. Checks that the file has the right number of delimiters in each row. If this box is selected, any rows that do not have the correct number of delimiters will be ignored. This function is useful when updating files.
Process Type
REFRESH - updates all fields (only data is dropped, all column definitions and meta-data persist and will contain a row of NULLs)
APPEND - appends the processed data to the current file
UPDATE - updates only changed fields (where no corresponding data exists, the data is appended)
UPDATE_ONLY - updates changed fields (where no corresponding data exists, the data is ignored)
Record Width
Specify the exact width, if possible, to conserve the space taken up in Engine.
Load Date
Enter in the format DDMMCCYY.
Skip first number of rows
Omits the specified number of rows, usually 1. Useful when importing data with headers.
Qualifier
Only active if the file format chosen is Delimited. Select None where data is numeric otherwise, select Quotes.
Owner
The default is SYSTEM, which is not shown in the script. If the owner name is changed, the new value is shown in the script.
Engine Specifics
Qualifier
Only active if the file format chosen is Delimited. Select None where data is numeric otherwise, select Quotes.
Owner
The default is System, which is not shown in the script. If this is changed, the value is shown in the script.
On completing the Table Declaration process, you can move on to the Table Definition process.
